CentOS 6
Sponsored Link

Web Site Access Log Report - Piwik
2014/09/15
 
Install Web Site Access Analyzer "Piwik". Piwik is different from AWStats and others, it analyzes a Web site, so it needs to add Java Script codes on a web site you'd like to analyze accesses.
[1]
Install PHP, refer to here.
[2]
Install MySQL Server, refer to here.
[3] Create a Database for Piwik.
[root@www ~]#
mysql -u root -p 

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.52 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
# create "piwik# database ( set any password for 'password' )

mysql>
create database piwik;

Query OK, 1 row affected (0.00 sec)
mysql>
grant all privileges on piwik.* to piwik@'localhost' identified by 'password';

Query OK, 0 rows affected (0.00 sec)
mysql>
flush privileges;

Query OK, 0 rows affected (0.00 sec)
mysql>
exit

Bye
[4] Install Piwik.
[root@www ~]#
yum -y install php-pdo php-gd php-xml
[root@www ~]#
vi /etc/php.ini
# line 457: increase memory limit

memory_limit =
512M
[root@www ~]#
wget http://piwik.org/latest.zip -P /var/www/html

[root@www ~]#
unzip /var/www/html/latest.zip -d /var/www/html

[root@www ~]#
chmod 777 /var/www/html/piwik/tmp

[root@www ~]#
chmod 777 /var/www/html/piwik/config

[5] Access to "http://(server's hostname or IP address)/piwik/" and Click "Next".
[6] Confirm system requirements. If it's all OK, Go next.
[7] Input Database's infomation.
[8] Tabales are created normally if Database's infomation is correct.
[9] Set admin user. Input any name and password you like. For email address field, input real email address on the internet.
[10] Input web site's information you'd like to analyze accesses.
[11] Java Script codes are generated like follows. You need to add it on your web site.
[12] Initial Setup is completed. Click "continue" to proceed.
[13] This is the login screen. Authenticate with a user you added
[14] This is main screen. Though no data is shown below, looks and feelings are good to use.
 
Tweet